<?php

class ArticlesFixture {
	
	public $tableName = 'articles';
	
	public $createSql = "CREATE TABLE IF NOT EXISTS `articles` (
	  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
	  `title` VARCHAR(255) NOT NULL,
	  `user_id` INT UNSIGNED NOT NULL,
	  `updated_date` DATETIME NOT NULL,
	  `created_date` DATETIME NOT NULL,
	  `content` TEXT NOT NULL,
	  PRIMARY KEY (`id`)
	ENGINE = InnoDB";
	
	public $data = array(
		array(
			'id'			=>	1,
			'title'			=>	'Test Article 1',
			'user_id'		=>	1,
			'created_date'	=> '2010-10-01 12:34:55',
			'update_date'	=>	'2010-10-01 12:34:55',
			'content'		=>	'This is a test article.  This is the text for test article 1.',
		),
		array(
			'id'			=>	2,
			'title'			=>	'Test Article 2',
			'user_id'		=>	1,
			'created_date'	=> '2010-10-01 12:34:55',
			'update_date'	=>	'2010-11-01 12:34:55',
			'content'		=>	'This is a test article.  This is the text for test article 2.',
		),
		array(
			'id'			=>	3,
			'title'			=>	'Test Article 3',
			'user_id'		=>	3,
			'created_date'	=> '2010-11-21 12:34:55',
			'update_date'	=>	'2010-11-21 12:34:55',
			'content'		=>	'This is a test article.  This is the text for test article 3.',
		),
		array(
			'id'			=>	4,
			'title'			=>	'Test Article 4',
			'user_id'		=>	3,
			'created_date'	=> '2010-10-01 12:34:55',
			'update_date'	=>	'2010-10-01 12:34:55',
			'content'		=>	'This is a test article.  This is the text for test article 4.',
		),
	);
	
}